﻿CREATE TABLE [dbo].[AD_Public] (
    [prop_id]      FLOAT          NULL,
    [geo_id]       NVARCHAR (255) NULL,
    [file_as_name] NVARCHAR (255) NULL,
    [addr_line1]   NVARCHAR (255) NULL,
    [addr_line2]   NVARCHAR (255) NULL,
    [addr_line3]   NVARCHAR (255) NULL,
    [addr_city]    NVARCHAR (255) NULL,
    [addr_state]   NVARCHAR (255) NULL,
    [addr_zip]     NVARCHAR (255) NULL,
    [latitude]     FLOAT          NULL,
    [longitude]    FLOAT          NULL
);

